﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Agresso.Interface.Layer.SQL
{
    public class InvoiceSQL
    {
        public static string InsertInvoice()
        {
            return @"
INSERT INTO i_Invoice
           ([batch_id]
           ,[FileName]
           ,[CreatedDate]
           ,[ModifiedDate]
           ,[pickup_flag]
           ,[Client]
           ,[CompanyCode]
           ,[SupplierId]
           ,[SupplierName]
           ,[VatId]
           ,[TaxNo]
           ,[Scandate]
           ,[DocumentType]
           ,[InvoiceDate]
           ,[InvoiceNumber]
           ,[Netamount]
           ,[Vatrate]
           ,[Vatamount]
           ,[Totalamount]
           ,[Currency]
           ,[line_no]
           ,[PONo]
           ,[POPosition]
           ,[Description]
           ,[DeliveryNoteNo]
           ,[Total]
           ,[Quantity]
           ,[Unitprice]
           ,[Unit])
     VALUES
           (
            ''
           ,@FileName
           ,getdate()
           ,getdate()
           ,'0'
           ,@Client
           ,@CompanyCode
           ,@SupplierId
           ,@SupplierName
           ,@VatId
           ,@TaxNo
           ,@Scandate
           ,@DocumentType
           ,@InvoiceDate
           ,@InvoiceNumber
           ,@Netamount
           ,@Vatrate
           ,@Vatamount
           ,@Totalamount
           ,@Currency
           ,@line_no
           ,@PONo
           ,@POPosition
           ,@Description
           ,@DeliveryNoteNo
           ,@Total
           ,@Quantity
           ,@Unitprice
           ,@Unit
            )
            ";
        }
    }
}
